UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u4zV9nTW4IvZ/H5ZRKiHL4tltYstnnuOHHM6jhUAqWc='
WHERE
key_id = 'bb57181b121d097c47e7e53b904c786afe4080a1bfced7f6727774aa486c4430'
AND (
token = 'u4zV9nTW4IvZ/H5ZRKiHL4tltYstnnuOHHM6jhUAqWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)