UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bpc4HR8XZ15aW3m8DR3W6obXTFvvxLwglXlJG0mUkJQ='
WHERE
key_id = '9cc1f60521c31c5b3b39a58384886a2e224993dcffa5bc17015def1af27f44d0'
AND (
token = 'bpc4HR8XZ15aW3m8DR3W6obXTFvvxLwglXlJG0mUkJQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)