UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HBLdIvRq1pp9dSIX85R2nX1YPUT+BE2fiFYa8Z/uCA='
WHERE
key_id = '1681ad625a47017ea0020e87fc328a8758e1bde06200242dcea57231f7c9722a'
AND (
token = '4HBLdIvRq1pp9dSIX85R2nX1YPUT+BE2fiFYa8Z/uCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)