UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TRliMDrCE/GJViqEY/9aQJX+4DbDPSJcOsX/RFZNQq8='
WHERE
key_id = 'a1cac4ee73044591287d159c359f10d86495a021a36dc0da46967ff37cb84ca2'
AND (
token = 'TRliMDrCE/GJViqEY/9aQJX+4DbDPSJcOsX/RFZNQq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)