UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Snpy0CYb58ankJr5sYCscTuon3KCENedi6xHnDi9wA='
WHERE
key_id = 'd5d56fbc0efa8be31536672e8b71c8640d03ac15af2108af5d2ea5c3eafcbb10'
AND (
token = '8Snpy0CYb58ankJr5sYCscTuon3KCENedi6xHnDi9wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)