UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QRzHTrdvIcL54QQElgwc1Wr8tYPk8tfgNQP77Up0OqQ='
WHERE
key_id = '47c489a336c5ca265cc8664164cb7774604bf99a5b5972b8864b13b8159797ea'
AND (
token = 'QRzHTrdvIcL54QQElgwc1Wr8tYPk8tfgNQP77Up0OqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)