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