UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ck9pIB4hvvGFTgF1rhTkOolU4JcUqn5UnPtQCAgtZks='
WHERE
key_id = '407a5c17e553fdc7dfd60d7a09add7c22e3ea80efcb2ab1a12861c19e6f49ae7'
AND (
token = 'ck9pIB4hvvGFTgF1rhTkOolU4JcUqn5UnPtQCAgtZks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)