UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wqgMa161ohV8UgoRO4bayN7WRVYh3ZCNDTb+HgJAZIU='
WHERE
key_id = 'f9a1bfc53cfc769ba05ce5ae8669ee2e4fe1c2b0e9feed1357bb8e82dd27b010'
AND (
token = 'wqgMa161ohV8UgoRO4bayN7WRVYh3ZCNDTb+HgJAZIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)