UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KzPNSeKnY2oCoFO86EWZrBiCkc/yHJd8m60sI2k+GRk='
WHERE
key_id = '734df3bbe4a84353a9678b6ecb508a00811b7e00927c8736987e86c14aed42b5'
AND (
token = 'KzPNSeKnY2oCoFO86EWZrBiCkc/yHJd8m60sI2k+GRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)