UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uW/CzpdhvTiFkljAE2qqNjLAisciM1Bai3FwHIkb7yo='
WHERE
key_id = 'c6d1c20d5f56663b4ef6b51441e9ab31caafc375de6328aaacf9d6716e37d6a3'
AND (
token = 'uW/CzpdhvTiFkljAE2qqNjLAisciM1Bai3FwHIkb7yo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)