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