UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzaAaFznqiToER3BV/3ez/vCP2ppU3tCJI6LZUpLjXI='
WHERE
key_id = '1d0343f6617ea2cc6e27756498f4dd4fe218c1bf0bcbe8efceb85e797e4f2f54'
AND (
token = 'hzaAaFznqiToER3BV/3ez/vCP2ppU3tCJI6LZUpLjXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)