UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPOlXpvT6+ooigx233gqWpLKyTEqmlbhSGyPd2TVVdU='
WHERE
key_id = 'c86dc69b751e73cd351836f9b3cdeafaa415ba7cccd3b321fb5e395d2eceb817'
AND (
token = 'BPOlXpvT6+ooigx233gqWpLKyTEqmlbhSGyPd2TVVdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)