UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pW7vRO44EMih3xkyfz6kks0R9vYcDP5ktffEl1xdmXM='
WHERE
key_id = 'f3d6788a99bfc65b317e4868a7c19a1258224262d96efe2cc2cc0fc03af67336'
AND (
token = 'pW7vRO44EMih3xkyfz6kks0R9vYcDP5ktffEl1xdmXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)