UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uVQNa4rOceSrLX93dmxug6weQ9pT0ReRSUqCSoUnQv8='
WHERE
key_id = '2ac5fa5c33bea683f1fda66837b8a59c4a42af279218bee36404b8358be2409e'
AND (
token = 'uVQNa4rOceSrLX93dmxug6weQ9pT0ReRSUqCSoUnQv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)