UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UibTEWOn3LIJxiWIvhjtpVkOOGTg59Emkyy3/7inq18='
WHERE
key_id = 'd86efd47c4b82065cb9ba2e872b0d21228b9b34dd7cc67b62e63232a2f6b422e'
AND (
token = 'UibTEWOn3LIJxiWIvhjtpVkOOGTg59Emkyy3/7inq18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)