UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5UVkl7VY1eWAzx/XvaxJL9CowMAh0BhRSSUDStSMH6s='
WHERE
key_id = '1374e7f03119c187e3cbfe04deda121ac422ec9009755eb9a8c45239457c9b2a'
AND (
token = '5UVkl7VY1eWAzx/XvaxJL9CowMAh0BhRSSUDStSMH6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)