UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '23hLDgQWVUThQK7/oSf2HJXHXtJSZwB6Y1mhMyMaLxA='
WHERE
key_id = '42bbfc7c72792426e0267fb396aabecff04618e4609996d2c173a311a9b061fb'
AND (
token = '23hLDgQWVUThQK7/oSf2HJXHXtJSZwB6Y1mhMyMaLxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)