UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G+PUVGmJuqpAHXYun5THs5M5/NZ3kTkxSU3kzzotD0I='
WHERE
key_id = 'aceb57d863d152eb15ad50515b6295d8daabf289ac4e6a473332578729aa7389'
AND (
token = 'G+PUVGmJuqpAHXYun5THs5M5/NZ3kTkxSU3kzzotD0I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)