UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WmyiV6LxcHYIgEdgZGRvAlwd4kmWyNZWT7+sURLdVuk='
WHERE
key_id = '9967f333178accb172d78921551260b04d15359b5c755dd1a0382f002e66aeb4'
AND (
token = 'WmyiV6LxcHYIgEdgZGRvAlwd4kmWyNZWT7+sURLdVuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)