UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0HmhY9paLK9tQ54CCcFChkjDl+gWDPWrvEPVjaPiZ0='
WHERE
key_id = '5928993514b3a0219ed130e0b6ae21a722e8fbd64406dffa1ba502596cfa348a'
AND (
token = 'a0HmhY9paLK9tQ54CCcFChkjDl+gWDPWrvEPVjaPiZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)