UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+QMxQnjPZrwgPC6Dw/avtW6xlalHinB3M6I81PI7Ps='
WHERE
key_id = 'a9466a5c4551bdf07141858a12d478cf4077c0945f5e0d46be2ba3d6da853e9c'
AND (
token = 'x+QMxQnjPZrwgPC6Dw/avtW6xlalHinB3M6I81PI7Ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)