UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yliQbZB2h02qBELXygIJs0Q6Ai35MZdwEXLmkwAyZCI='
WHERE
key_id = 'b17f807a180dc326a4b8c167a6ef18da55c1574c8bb664a610aa52c68860268f'
AND (
token = 'yliQbZB2h02qBELXygIJs0Q6Ai35MZdwEXLmkwAyZCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)