UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZ8EGoD8RekQ2JZ0pBhBAUp1gpRflyU3/MpTc2q7d3E='
WHERE
key_id = '189258157a903aa99fbbd721fe185b241e44d0d94f9cbfed030389a890749deb'
AND (
token = 'HZ8EGoD8RekQ2JZ0pBhBAUp1gpRflyU3/MpTc2q7d3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)