UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w8aXaHF32feo9z7OSEsoeqy95n/q9mHZkQTPw7LOIlQ='
WHERE
key_id = '8bf40e7f5fe01aa8940e6c0fd5785a8c56058aec50e4dd303e1eb58630538a8c'
AND (
token = 'w8aXaHF32feo9z7OSEsoeqy95n/q9mHZkQTPw7LOIlQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)