UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+4cGQcf+TcI2yclIGjpz6VeTO4d2JrMjSTOJYdI5pT4='
WHERE
key_id = 'd70791e87177e7900cae3642e476d12ddc83520c2dca385086a33f873e4404b4'
AND (
token = '+4cGQcf+TcI2yclIGjpz6VeTO4d2JrMjSTOJYdI5pT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)