UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9/3HMWJykcbtFZ0VftMjAIcldCgt//0DAjDIDZT8jeU='
WHERE
key_id = 'a28a2bc432c3e575816f1f296a6876441de37e7167bfa1b790c36bb4125e68b2'
AND (
token = '9/3HMWJykcbtFZ0VftMjAIcldCgt//0DAjDIDZT8jeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)