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