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