UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i+pMAF2IcjqJeNlBBZnSr+1xg4MHAM+QpS8yK242S64='
WHERE
key_id = '20bbe09c22d12582ccbca43c570e5ecd1dcc57a33dd3193bf7fbb2008e1e14c7'
AND (
token = 'i+pMAF2IcjqJeNlBBZnSr+1xg4MHAM+QpS8yK242S64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)