UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n83OuFI/uI6eth72xXXLCwsyUuVao5NAMf6sDcFaX+M='
WHERE
key_id = 'ae27d6fa231f3a81f2a21812dfba700f785dedf7e59ac2761f3b9f26822daff8'
AND (
token = 'n83OuFI/uI6eth72xXXLCwsyUuVao5NAMf6sDcFaX+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)