UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+V5zFzMpgImUef0eylGsFkfuCLIZ4ygoTcnivVWZqY='
WHERE
key_id = '0867342358c69cefc9853e2f2d1a7a700b6f9d82840a99e83984b1f9efbcaf32'
AND (
token = 'r+V5zFzMpgImUef0eylGsFkfuCLIZ4ygoTcnivVWZqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)