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