UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VYmjrdPXnZoJI/iueGKaerJfWzXrZdk6iniaP/XhDTs='
WHERE
key_id = '48746f691267e8696976591862ef34c19c46f5cbc8e023d766f3d2df5feff52a'
AND (
token = 'VYmjrdPXnZoJI/iueGKaerJfWzXrZdk6iniaP/XhDTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)